Table: Banks

Table: BKACCT
View: BK0001
Record length: 999
Flags: A R 

Keys: 1

Title  Flags  Fields

Bank Code   BANK

Fields: 60

Field  Type  Title  Presentation 

BANK  String*8  Bank Code  Mask: %-8N
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
NAME  String*60  Description   
ADDR1  String*60  Address Line 1   
ADDR2  String*60  Address Line 2   
ADDR3  String*60  Address Line 3   
ADDR4  String*60  Address Line 4   
CITY  String*30  City   
STATE  String*30  State/Province   
COUNTRY  String*30  Country   
POSTAL  String*20  Zip/Postal Code   
CONTACT  String*60  Contact   
LOCTYPE  String*6     
LOCATION  String*30     
PHONE  String*30  Phone Number  Mask: (%-3C) %-3C-%-24C
FAX  String*30  Fax Number  Mask: (%-3C) %-3C-%-24C
TRANSIT  String*12  Transit Number  Mask: %-12D
MULTICUR  Boolean  Multicurrency  List: 2 entries
0=No
1=Yes
CURNSTMT  String*3  Statement Currency  Mask: %-3N
INACTIVE  Boolean  Status  List: 2 entries
0=Active
1=Inactive
INACTDATE  Date  Inactive Date   
BKACCT  String*22  Bank Account Number   
RECNSFTYPE  String*6     
IDACCT  String*45  Bank G/L Account  Mask: %-45C
IDACCTERR  String*45  Clearing Errors G/L Account  Mask: %-45C
ERRSPREAD  BCD*10.3  Error Spread   
LSTMNTND  Date  Last Maintained   
RECFY  String*4  Fiscal Year  Mask: %4D
RECFP  Integer  Fiscal Period  List: 12 entries
1=1
2=2
3=3
4=4
5=5
6=6
7=7
8=8
9=9
10=10
11=11
12=12
RECLSTFY  String*4  Last Reconciliation Year   
RECLSTFP  Integer  Last Reconciliation Period   
RECLSTDATE  Date  Last Reconciliation Date   
RECLSTBAL  BCD*10.3  Last Closing Statement Balance   
RECDATE  Date  Reconciliation Date   
RECSTMTDAT  Date  Statement Date   
RECSTMTBAL  BCD*10.3  Statement Balance   
RECINTRANS  BCD*10.3  Deposits in Transit   
RECOUTSTND  BCD*10.3  Checks Outstanding   
RECBKERRPN  BCD*10.3  Bank Errors   
RECBKENT  BCD*10.3  Bank Entries   
RECBKERR  BCD*10.3  Write-Offs   
RECEXGAIN  BCD*10.3  Exchange Gain   
RECEXLOSS  BCD*10.3  Exchange Loss   
RECDEPOSIT  BCD*10.3  Total Deposits   
RECCHECK  BCD*10.3  Total Checks   
RECFCDEP  BCD*10.3  Deposits To Fiscal Period   
RECFCCHK  BCD*10.3  Checks To Fiscal Period   
RECFCDEPIT  BCD*10.3  Deposits In Transit To Fisc.Per.   
RECFCCHKOS  BCD*10.3  Checks Outstanding To Fisc.Per.   
RECRECALC  Boolean  Calculate Fiscal Period Data  List: 2 entries
0=Fiscal balances are up to date.
1=Fiscal balances need to be recalculated.
RECLSMDATE  Date  Last Statement Date   
RECFCBKENT  BCD*10.3  Bank Entries To Fiscal Period   
RECFCGAIN  BCD*10.3  Exchange Gain To Fiscal Period   
RECFCLOSS  BCD*10.3  Exchange Loss To Fiscal Period   
RECFCERRPN  BCD*10.3  Bank Error Pending To Fiscal Per   
RECFCERR  BCD*10.3  Bank Error To Fiscal Period   
RECFCENTRE  BCD*10.3  Reconciled Entries To Fiscal Per   

This page was generated on 2004-Oct-28

Copyright © 2000–2004 ACCPAC International, Inc. All rights reserved.